National_Pride_Large

	Data/import.do:261
→	Data/EVC_da.._Data_Taxing_Wages.csv	↘
	Data/import.do:260		Data/EVC_da..a_Taxing_Wages2013.csv Data/EVC_da..a_Taxing_Wages2013.dta Data/EVC_da.._Data_Taxing_Wages.csv Data/EVC_da.._Data_Taxing_Wages.dta

Data/EVC_data/OECD data/Comparative tables (current model) taxing wages/AWCOMP_Data_Taxing_Wages.csv open
file:data:csv

All properties
key	content
N	54392
_runCommand	import delimited
datasignature	54392:6(68621):1553267082:4031919409
date	Thu Dec 12 00:54:42 EST 2013
lastmodified	1386773682000
variables	6

Variable Graph Type N Descriptives Label

[+] country
@AWCOMP_Data_Taxing_Wages.csv

string
(str15)

54392
(35)

Country

All properties
key	content
N	54392
N_unique	35
class	string
example0	Australia
label	Country
type	str15

Data Manipulations with country
file	#	command

Script Output

@example0 Australia
@type str15
@label Country
@class string
@N_unique 35
@N 54392

[+] familytype
@AWCOMP_Data_Taxing_Wages.csv

category
(str92)

54392
(8)

"One-earner married couple at 100.. %, 2 children"

Family type

All properties
key	content
N	54392
N_unique	8
class	category
freq	6799, 6799, 6799, 6799, 6799, 6799, 6799, 6799
label	Family type
type	str92
values	"One-earner married couple at 100% of average earnings, 2 children", "Single person at 100% of average earnings, no child", "Single person at 167% of average earnings, no child", "Single person at 67% of average earnings, no child", "Single person at 67% of average earnings, with two children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, 2 children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, no child", "Two-earner married couple, one at 100% of average earnings and the other at 67 %, 2 children"

Data Manipulations with familytype
file	#	command

Script Output

@freq 6799, 6799, 6799, 6799, 6799, 6799, 6799, 6799
@values "One-earner married couple at 100% of average earnings, 2 children", "Single person at 100% of average earnings, no child", "Single person at 167% of average earnings, no child", "Single person at 67% of average earnings, no child", "Single person at 67% of average earnings, with two children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, 2 children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, no child", "Two-earner married couple, one at 100% of average earnings and the other at 67 %, 2 children"
@type str92
@label Family type
@class category
@N_unique 8
@N 54392

[+] flags
@AWCOMP_Data_Taxing_Wages.csv

empty
(byte)

0
(0)

Flags

All properties
key	content
N	0
N_unique	0
class	empty
example0	.
label	Flags
mean	.
type	byte

Data Manipulations with flags
file	#	command

Script Output


flags:  Flags                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|                            Negative           -         -          -
|                            Zero               -         -          -
|                            Positive           -         -          -
|                                           -----     -----      -----
|                            Total              -         -          -
|                            Missing        54392
+----------------------                     -----
.             -9.0e+307                     54392
   (0 unique value)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       flags |         0
@mean         .
@sd 
@min 
@max 
@example0 .
@type byte
@label Flags
@class empty
@N_unique 0
@N 0

[+] indicator
@AWCOMP_Data_Taxing_Wages.csv

category
(str84)

54392
(15)

"Average income tax rate (%)", "A..xchange rates)"

Indicator

All properties
key	content
N	54392
N_unique	15
class	category
freq	3640, 3640, 3640, 3640, 3640, 3640, 3640, 3640, 3640, 3536, 3640, 3640, 3640, 3536, 3640
label	Indicator
type	str84
values	"Average income tax rate (%)", "Average rate of employees' social security contributions (%)", "Average rate of employer's social security contributions (%)", "Average rate of income tax and employees' social security contributions (%)", "Average tax wedge (%)", "Increase in net income after an increase of 1 currency unit in gross labour cost (%)", "Increase in net income after an increase of 1 currency unit in gross wages (%)", "Marginal tax wedge: Principal earner (%)", "Net income after taxes ( in US dollars using PPP exchange rates)", "Net income after taxes (national currency)", "Net personal average tax rate (%)", "Net personal marginal tax rate: Principal earner (%)", "Total gross earnings before taxes (in US dollars using PPP exchange rates)", "Total gross earnings before taxes (national currency)", "Total gross labour costs before taxes (in US dollars using PPP exchange rates)"

Data Manipulations with indicator
file	#	command

Script Output

@freq 3640, 3640, 3640, 3640, 3640, 3640, 3640, 3640, 3640, 3536, 3640, 3640, 3640, 3536, 3640
@values "Average income tax rate (%)", "Average rate of employees' social security contributions (%)", "Average rate of employer's social security contributions (%)", "Average rate of income tax and employees' social security contributions (%)", "Average tax wedge (%)", "Increase in net income after an increase of 1 currency unit in gross labour cost (%)", "Increase in net income after an increase of 1 currency unit in gross wages (%)", "Marginal tax wedge: Principal earner (%)", "Net income after taxes ( in US dollars using PPP exchange rates)", "Net income after taxes (national currency)", "Net personal average tax rate (%)", "Net personal marginal tax rate: Principal earner (%)", "Total gross earnings before taxes (in US dollars using PPP exchange rates)", "Total gross earnings before taxes (national currency)", "Total gross labour costs before taxes (in US dollars using PPP exchange rates)"
@type str84
@label Indicator
@class category
@N_unique 15
@N 54392

[+] value
@AWCOMP_Data_Taxing_Wages.csv

other
(float)

54392
(.)

(x̄=2.05e+05, 2.25e+06) [-45.062,6.42e+07]

Value

All properties
key	content
N	54392
N_unique	.
class	other
example0	41876.738
histh	7.184e-07, 2.542e-09, 2.959e-09, 2.098e-09, 1.587e-09, 6.456e-10, 4.708e-10, 9.415e-11, 1.345e-11, 6.725e-11, 5.380e-11, 5.380e-11, 8.070e-11, 9.415e-11, 1.345e-10, 1.211e-10, 1.749e-10, 9.415e-11, 1.076e-10, 9.415e-11, 9.415e-11, 6.725e-11, 1.345e-10, 8.070e-11, 1.480e-10, 1.076e-10, 8.070e-11, 5.380e-11, 1.211e-10, 8.070e-11, 5.380e-11, 6.725e-11, 9.415e-11, 8.070e-11, 1.345e-11, 8.070e-11, 2.690e-11, 6.725e-11, 4.035e-11, 4.035e-11, 2.690e-11, 5.380e-11, 1.345e-11, 2.690e-11, 2.690e-11, 2.690e-11
histw	683401.88, 2050295.8, 3417189.8, 4784083.5, 6150977.5, 7517871.5, 8884765, 10251659, 11618553, 12985447, 14352341, 15719235, 17086128, 18453022, 19819916, 21186810, 22553704, 23920598, 25287492, 26654386, 28021280, 29388174, 30755068, 32121962, 33488856, 34855748, 36222644, 37589536, 38956432, 40323324, 41690220, 43057112, 44424008, 45790900, 47157796, 48524688, 49891584, 51258476, 52625368, 53992264, 55359156, 56726052, 58092944, 60826732, 62193628, 63560520
label	Value
max	6.42e+07
mean	2.05e+05
min	-45.062
sd	2.25e+06
type	float

Data Manipulations with value
file	#	command

Script Output


value:  Value                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|  #                         Negative         416         -        416
|  #                         Zero             680       680          -
|  #                         Positive       53296      3844      49452
|  #                                        -----     -----      -----
|  #                         Total          54392      4524      49868
|  #   .   .   .   .         Missing            -
+----------------------                     -----
-45.062        6.42e+07                     54392
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       value |     54392      204808     2249387    -45.062   6.42e+07
@mean  2.05e+05
@sd  2.25e+06
@min   -45.062
@max  6.42e+07
@example0 41876.738
@histh 7.184e-07, 2.542e-09, 2.959e-09, 2.098e-09, 1.587e-09, 6.456e-10, 4.708e-10, 9.415e-11, 1.345e-11, 6.725e-11, 5.380e-11, 5.380e-11, 8.070e-11, 9.415e-11, 1.345e-10, 1.211e-10, 1.749e-10, 9.415e-11, 1.076e-10, 9.415e-11, 9.415e-11, 6.725e-11, 1.345e-10, 8.070e-11, 1.480e-10, 1.076e-10, 8.070e-11, 5.380e-11, 1.211e-10, 8.070e-11, 5.380e-11, 6.725e-11, 9.415e-11, 8.070e-11, 1.345e-11, 8.070e-11, 2.690e-11, 6.725e-11, 4.035e-11, 4.035e-11, 2.690e-11, 5.380e-11, 1.345e-11, 2.690e-11, 2.690e-11, 2.690e-11
@histw 683401.88, 2050295.8, 3417189.8, 4784083.5, 6150977.5, 7517871.5, 8884765, 10251659, 11618553, 12985447, 14352341, 15719235, 17086128, 18453022, 19819916, 21186810, 22553704, 23920598, 25287492, 26654386, 28021280, 29388174, 30755068, 32121962, 33488856, 34855748, 36222644, 37589536, 38956432, 40323324, 41690220, 43057112, 44424008, 45790900, 47157796, 48524688, 49891584, 51258476, 52625368, 53992264, 55359156, 56726052, 58092944, 60826732, 62193628, 63560520
@type float
@label Value
@class other
@N_unique .
@N 54392

[+] year
@AWCOMP_Data_Taxing_Wages.csv

category
(int)

54392
(13)

"2000", "2001", "2002", "2003", ".. "2011", "2012"

Year

All properties
key	content
N	54392
N_unique	13
class	category
freq	4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184
label	Year
max	2012
mean	2006.000
min	2000
names	"2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012"
sd	3.742
type	int
values	2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012

Data Manipulations with year
file	#	command

Script Output


year:  Year                                     Number of Observations
-----------                                 ------------------------------
                                            Total   Integers   Nonintegers
|  #       #       #         Negative           -         -          -
|  #       #       #         Zero               -         -          -
|  #   #   #   #   #         Positive       54392     54392          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total          54392     54392          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
2000               2012                     54392
  (13 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |     54392        2006    3.741692       2000       2012
@mean  2006.000
@sd     3.742
@min      2000
@max      2012
@values 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012
@names "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012"
@freq 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184
@type int
@label Year
@class category
@N_unique 13
@N 54392

Content



>  * A do file to run the standard stats for a whole data set. 
>  *
>  * Note that you must delete the files in the derived directory
>  * for changes to be reflected in the output.
>  *
>  * @version 0.1
> */
(6 vars, 54392 obs). 

Contains data
  obs:        54,392                          
 vars:             6                          
 size:    10,769,616                          
Sorted by:  
     Note:  dataset has changed since last saved
@N 54392
@variables 6
  54392:6(68621):1553267082:4031919409
@datasignature 54392:6(68621):1553267082:4031919409
panel variable not set; use xtset varname ...
.

- - Tokens
    AWCOMP AWCOMP Data csv Data Data Taxing Taxing Taxing Wages Wages Wages csv

File AWCOMP_Data_Taxing_Wages.csv

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Content

Tokens